<%@ page language="java" contentType="text/html; charset=ISO-8859-1"
    pageEncoding="ISO-8859-1"%>
<!DOCTYPE html PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN" "http://www.w3.org/TR/html4/loose.dtd">
<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=ISO-8859-1">
<title align="CENTER">Volume details</title>

<style type="text/css">
@import "flip-tabs.css";
</style>
<script type="text/javascript" src="flip-tab.js">
</script>
<script type="text/javascript">
  document.write('<style type="text/css">');  
  document.write('div.flip-tabs div{display:none;}<');
  document.write('/s'+'tyle>'); </script>

</head>
<body style="background-color:darkseagreen;">
<image align="right" src=Capture.jpg width=100 height=100 font size=4 color=black>
<h1 align="center"><font color=blue>STORAGE INVENTORY</font></h1>

<table cellpadding="6" border="2" width="750">


<div id="flip-tabs">
        <ul id="flip-navigation">
 		<li> <a href="Aggregade.jsp" id="tab-2">Aggregade Details</a> </li>
      <li> <a href="Disk.jsp" id="tab-5">Disk Details</a> </li>
      <li> <a href="vol.jsp" id="tab-1">volume Details</a> </li>
      <li><a href="lun.jsp" id="tab-3">Lun Details</a> </li>
      <li> <a href="Qtree.jsp" id="tab-4">Qtree Details</a> </li>
            <li> <a href="HomePage.jsp" id="tab-6">Home</a> </li>
   
    </ul>
    <div id="flip-container">
    </div>
    
 </div> 

   
	 

<tr>

      <th bgcolor="#5D7B9D"><font color="#fff">volname</font></th>
      <th bgcolor="#5D7B9D"><font color="#fff"> state</font></th>
      <th bgcolor="#5D7B9D"><font color="#fff"> status</font></th>
      <th bgcolor="#5D7B9D"><font color="#fff"> Utilization</font></th>
      <th bgcolor="#5D7B9D"><font color="#fff"> v_uuid</font></th>

  </tr>
  <font size="4" align="middle" color="blue">Volume Details</font> 
 <%@ page import= "java.sql.*;"%>
<%  Connection con=null;
      Statement st=null;
     
      ResultSet rs=null;
      PreparedStatement pt=null;
      
 
	String volname,state,status,utl,v_uuid,aggrname;
try
	{
	Class.forName("com.mysql.jdbc.Driver").newInstance();
	con = DriverManager.getConnection("jdbc:mysql://localhost/netapp", "root", "rr");
	
	
                pt=con.prepareStatement("select * from volume");
	  rs=pt.executeQuery();
              while( rs.next())
	  {
	  volname=rs.getString(1);
	  state=rs.getString(2);
	  status=rs.getString(3);
	  aggrname=rs.getString(4);
	  
	  utl=rs.getString(5);
	  
	  
	  v_uuid=rs.getString(6);

	 
	  out.println("<TR>");
      
      out.println("<TD>"+"<image src=1.jpeg width=10 height=10 ><font size=4 color=blue>  " + volname +"</font>"+ "</TD>");
      out.println("<TD>"+"<image src=1.jpeg width=10 height=10 ><font size=4 color=blue>  " + state +"</font>"+ "</TD>");
      out.println("<TD>"+"<image src=1.jpeg width=10 height=10 ><font size=4 color=blue>  " + status +"</font>"+ "</TD>");
      out.println("<TD>"+"<image src=1.jpeg width=10 height=10 ><font size=4 color=blue>  " + utl +"</font>"+ "</TD>");
      out.println("<TD>"+"<image src=1.jpeg width=10 height=10 ><font size=4 color=blue>  " + v_uuid +"</font>"+ "</TD>");
      out.println("</TR>");

 
	  
      
	  
	}
              }
catch(Exception e)
{
 	out.println(e);
}
%>

 </TABLE>

</body>
</html>